SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045442 LIMIT 1 [ RunTime:0.001553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045442 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135210,400322,345346,1043469,1019294,841180,993670,424304,920071,589647,814502,103372,34066,522973,614945,433778,111653,573793,282309,263110,649623,915981,998611,652550,869334,220177,1042307,43512,449473,702284,11625,206733,325468,30784,597693,782395,895897,519745,729094,573094,795091,829151,52380,947175,678728,302946,25988,1018835,170684,522008,632662,417982,12629,339730,769296,422147,944077,463990,814861,998605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003783s ]