SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565407 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565407 [ RunTime:0.006110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723582,380220,588111,761573,1044851,57823,640213,518112,794760,416135,410653,124469,723510,939510,589812,452756,372715,983982,714105,406431,947770,631741,300652,807866,818462,1031234,2405,671793,678241,391441,473701,364082,783212,717014,167442,356766,371168,903004,244272,378246,61516,378085,383598,43665,248457,32230,714962,518847,174078,915321,734326,540122,781689,630975,959487,857796,309602,140871,531164,801767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001291s ]