SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345091 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345091 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172447,746862,473629,564240,464505,412263,492366,330484,83707,1040771,576125,693940,52064,540473,965644,544722,80770,835707,11088,105104,580208,226482,110253,709844,845657,884276,262324,957114,53592,799086,896403,859380,500679,837105,310142,795075,300931,477658,421111,817657,968538,912353,845554,578748,88360,811943,816105,189317,121077,209676,468419,224773,270093,381870,514304,524975,290673,440306,603044,564268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]