SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542941 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542941 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113069,376387,752040,958897,200709,173958,603112,108634,649351,872030,893123,513680,1005008,525127,1022707,301564,368608,225798,916881,324011,373674,552240,922255,524048,37210,503295,741713,279452,506926,51096,216619,383605,16146,473737,206438,480330,778106,665925,214994,72551,432295,471575,185499,910922,127295,431871,549723,59966,204087,977175,762044,1034715,176675,754409,704494,1022759,76787,313060,401246,166752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]