SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180133 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180133 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674599,594369,1010533,337834,889541,620528,170407,671263,1009127,837079,216358,179350,1028067,866543,615211,539851,107198,12299,405391,369884,103493,785698,104981,755924,988762,19092,698406,677943,269187,416118,875575,890637,976414,938450,971252,286131,66824,617932,612758,197868,999477,1022997,663905,689317,755258,604976,1025996,309896,473140,671141,657873,267194,318118,531139,874753,979689,325900,102685,193437,378937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]