SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101985 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101985 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137032,591300,256724,1010774,156475,552369,34431,1020065,200316,970918,1005179,1024258,862536,605630,738521,139692,12189,812057,851360,876207,1011234,349266,527458,949487,818607,7816,109718,1025945,101671,1002596,589418,903267,711839,757757,117868,978505,3052,545275,252416,453995,537094,1024052,234450,1033716,483209,970800,1038741,32356,787602,163415,333280,890030,83242,515030,1016244,804265,192638,35934,373615,799194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]