SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543942 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543942 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432069,784267,977918,332085,322523,897816,713611,341620,746177,206556,559530,155115,917267,868091,296233,600045,638138,775576,565247,430861,184335,419719,801647,268675,795236,833175,393673,30147,56976,679456,353550,411355,325549,824943,181007,682326,823853,385265,409811,192866,632662,52263,1035177,234973,744466,49235,958660,929207,966591,708462,627216,84436,275220,807570,814386,159582,261465,323210,563631,502940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]