SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368231 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368231 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554803,188900,265792,821041,808345,626712,783325,301626,1577,925784,799368,436300,585744,425223,725150,176335,393089,143560,1032073,921378,877468,199109,792574,550323,892296,887418,686610,569719,216478,172231,158034,846124,457483,674058,1029746,901974,532182,533089,465539,408440,133759,484749,353150,639197,725759,188240,914753,2226,87457,792077,479666,278921,494702,665148,878350,254328,148425,591611,180040,136277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]