NotORM demo

Software

4 applications tagged MySQL (all).

Title Author Tags
Adminer
Database management in a single PHP file
Jakub Vrana PHP MySQL Database
Dibi
Dibi - smart database abstraction layer
David Grudl PHP MySQL Database
MariaDB
The open source relational database
Michael Widenius MySQL Database
MySQL
Open source relational database
Michael Widenius MySQL Database
#1 index.php:21 0.14 ms
$tag = $db->tag[$_GET["tag"]]
SELECT id, name
FROM tag
WHERE (id = '202')
#2 index.php:37 0.05 ms
$count = $applications->count("*")
SELECT COUNT(*)
FROM application
LEFT JOIN application_tag ON application.id = application_tag.application_id
WHERE (application_tag.tag_id = '202')
#3 index.php:46 0.04 ms
foreach ($applications->order($order, "application.id")->limit($perPage, $offset) as $application)
SELECT application.id, application.title, application.slogan, application.author_id
FROM application
LEFT JOIN application_tag ON application.id = application_tag.application_id
WHERE (application_tag.tag_id = '202')
ORDER BY title, application.id
LIMIT 10
#4 index.php:49 0.04 ms
a("author.php?id=$application[author_id]", $application->author["name"])
SELECT id, name
FROM author
WHERE (author.id IN (101, 102, 109))
#5 index.php:50 0.03 ms
foreach ($application->application_tag() as $application_tag)
SELECT application_id, tag_id
FROM application_tag
WHERE (application_tag.application_id IN (301, 304, 323, 322))
#6 index.php:51 0.03 ms
h($application_tag->tag["name"])
SELECT id, name
FROM tag
WHERE (tag.id IN (201, 202, 207))