SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291018 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291018 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537082,984830,597356,672216,625068,850573,572233,1048139,373882,933564,10082,402607,967666,452329,401342,1017909,12314,846070,651255,614402,614689,282212,616726,939717,1018989,845182,851890,691812,57363,527333,701685,188365,218768,995273,881287,192235,796786,927036,412137,498844,987141,627520,605049,627312,1006994,451995,861335,112901,412158,40634,1035264,329390,904476,452,736922,424725,28163,310521,453936,928499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]