SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3280 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3280 [ RunTime:0.003247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106623,830546,492202,140025,578584,990704,472430,699661,179352,814340,877972,491178,944096,247779,64246,383527,394616,959631,1004673,806762,311099,1037497,350857,864589,667264,386896,737304,169537,25144,585328,982877,343739,303995,351459,689657,534870,812448,664701,633075,222328,336569,208160,917456,657394,870443,617407,652237,347241,178216,589339,601880,436855,268586,473963,811293,159227,288377,78410,250253,996375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]