SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515310 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515310 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200936,673639,775254,734746,778335,534585,168488,61600,175779,877587,866532,241032,1012204,514119,216883,620129,840995,746480,89977,914245,26946,187770,404059,973563,403588,703450,584999,760840,746717,774522,718021,820041,426339,415387,295135,983176,924496,564288,650534,492987,525265,657041,481962,601066,33410,936357,389443,510814,699186,3941,370495,455842,843832,604846,394361,83304,243918,274479,404962,394901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]