SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506748 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506748 [ RunTime:0.005504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475131,737661,650945,188974,632129,656343,761915,737316,893956,545374,496011,781011,1042768,333698,304772,221841,726619,574194,819075,247560,638966,1019146,752500,580977,713350,936604,649490,456563,478477,726888,749890,113789,179834,288593,905565,112846,754463,468033,728544,494112,324257,161502,644082,137993,48325,805255,854262,1020770,986907,603465,292378,899798,127900,67114,954648,804742,156203,167423,432560,726620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]