SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337462 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337462 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028169,243087,540838,1038125,112072,4279,144100,435352,631837,189071,400863,268002,904386,801272,1020944,771318,100477,152354,187096,126384,99298,377312,320990,942185,648713,124529,778677,953332,705405,108029,161512,799317,380739,348348,1026396,351321,951879,688193,800138,194689,730293,886835,1018710,48104,643769,1015447,476107,28966,782711,380995,996812,714780,471439,586337,551369,626558,833818,1020054,862634,1009361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]