SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986092 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986092 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42181,832984,604933,677770,622222,1009473,576339,3866,397498,17670,28982,30632,879876,489340,286242,74433,230919,10179,278332,364030,655350,406051,396255,1022028,678716,317604,429891,382018,394369,1014304,177007,479392,301539,370076,484459,716319,832135,627498,189726,630371,3538,954926,467004,647819,212594,248120,242742,901500,927402,248691,81738,996658,103041,26407,361036,604311,950694,492369,546703,194960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]