SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308213 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308213 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907169,971026,87820,291925,25438,213860,829556,808345,1009419,391635,72885,1024509,370827,137870,477596,619405,662352,865534,1043915,396510,691767,890717,931770,853876,302081,887903,1026379,593130,603490,489096,880867,807422,332191,172645,988560,259021,188797,451613,403780,539938,145114,610850,164994,97228,698067,177363,858912,1022266,421283,1002374,6512,850320,1011630,596069,778367,1016170,220664,892125,775843,357852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]