SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 16018 LIMIT 1 [ RunTime:0.001889s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 16018 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404981,660083,146688,449836,1000014,753044,998616,766469,299716,86834,242844,249639,305578,1025491,526041,679425,173385,259791,152146,716128,788541,57966,223381,473001,2213,638181,599622,489361,204947,524136,987414,106983,563665,443703,9848,545779,758175,126636,68066,427612,157531,158355,829278,237299,949032,944889,354215,584141,183552,244267,900844,1024130,851480,327221,530257,965329,262298,216877,874108,536707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 16018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 16018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]