SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335218 LIMIT 1 [ RunTime:0.002402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335218 [ RunTime:0.003349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027117,466951,193821,297025,442973,953196,656819,372764,39372,359653,968077,720081,426764,665140,372261,566034,31137,422775,317447,398071,540056,105076,117345,530222,99541,904195,815482,710006,566259,853356,914281,689620,165108,937153,629825,273360,295563,800486,881379,230005,1158,515862,531333,437845,511640,506732,399307,822968,688614,682294,136273,833151,449477,249275,146864,911971,719812,372953,171904,979244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]