SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581495 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581495 [ RunTime:0.002407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003415,279783,456507,90934,90091,473888,15944,341500,440766,1035479,578229,346678,557876,234476,424931,78179,972077,432774,1001133,252826,96798,474966,415326,104055,257481,18007,48894,603841,531697,476977,459593,941635,444031,1281,555312,758656,929197,862999,678711,270749,908522,623527,919002,731067,50631,109494,865735,783780,736937,720699,450390,957525,232959,358700,100146,500249,1038478,387343,868146,383824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]