SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981094 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981094 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558208,1009983,1008099,593022,864231,743398,772399,168738,554630,466042,752183,685645,19709,224037,885861,125763,306984,864640,260427,1029202,109924,674045,946235,229543,619219,267735,436423,942872,640061,631419,939007,51475,510739,687707,733088,915228,95007,657057,894021,661946,663745,38358,386350,820066,1011920,668819,345252,720051,694815,386761,554965,942754,448808,11528,619296,973820,951171,169057,346495,1040947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]