SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287093 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287093 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207041,709468,542170,266265,691895,883904,396332,584389,324728,630933,380079,663406,587837,760149,505549,740545,605547,1025078,296916,1012155,212534,576669,604085,232052,298653,926705,79311,417716,445604,1048631,523132,1039784,667809,117622,200711,478465,387105,478132,394210,749126,188257,411639,433664,53817,1015389,263048,227153,834870,493906,6029,633161,1009957,912343,152697,757751,973663,444842,616022,949310,228226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]