SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040823 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040823 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375278,537387,914233,1039530,931300,719794,454008,317898,499250,142920,531537,83734,143508,720870,6465,395837,764115,5091,333213,327105,1045435,487684,1006053,540793,54571,901543,584894,3548,247338,462513,532523,964701,962354,799499,763890,805958,816666,595737,268676,148954,417439,852500,20690,492163,802413,506355,646502,652590,119188,263155,643590,833814,207718,599677,787094,552648,742794,384223,751296,52226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]