SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416380 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416380 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56163,927427,218024,912097,339820,545229,841989,252196,449412,728388,18186,846527,841465,581931,802076,254760,810345,331377,734365,288085,402712,321650,99973,979069,838123,54722,622718,886115,274802,707030,503138,206641,379510,237628,790586,447504,32218,375143,384814,998676,240564,151705,82866,67998,781089,48429,190957,780390,421111,403912,510072,880039,257730,582755,292245,586171,276926,850538,934510,727340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]