SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103719 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103719 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003144,1021397,408947,702886,460957,499341,1039946,490657,884349,525496,438562,579432,843813,959883,620902,667878,744799,214641,458268,836290,678428,371479,223715,452986,891815,68577,824287,290653,399206,365530,228163,581736,666915,127978,1002011,752987,948962,579612,389488,190371,229068,578811,309914,689210,114324,114838,4550,627746,296703,41348,783943,635613,80164,82595,909920,182630,118367,910981,565328,75215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]