SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045409 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045409 [ RunTime:0.004356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12345,683817,1033116,1000881,622823,694958,761173,403282,83871,803095,569718,169343,938264,578971,585339,176126,603645,25837,856350,395281,655629,118058,19050,647479,887408,367018,232113,719509,766461,1011267,874683,383988,314027,820558,75891,293135,147352,147083,271570,174383,794127,15202,171382,765673,775220,1020326,702779,637815,694149,435524,900320,470748,761948,647517,675138,730552,483028,657771,65826,243389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]