SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482107 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482107 [ RunTime:0.003137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723003,446193,94312,425219,426320,451109,429594,344182,686967,472954,1043915,152693,95814,152063,534890,32599,637402,749331,382308,924361,1567,942839,719895,833136,615632,665267,560662,146607,1001908,948720,579059,557473,511424,1023349,39911,546184,494325,678519,849750,605937,806610,465646,509070,982687,220676,24937,442834,545545,423246,826605,631427,989162,592325,790111,752348,253475,157192,264935,423917,230424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]