SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023600 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023600 [ RunTime:0.003374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790854,861566,747802,964414,427187,131881,420513,1029899,960294,150741,940308,798457,849895,114082,758634,173994,264603,399719,838481,739794,652542,36482,139625,728195,849072,745395,117498,389492,697294,396820,22771,214865,708185,63627,742575,786076,511184,226450,1035132,367331,577486,204088,420327,188409,759105,1013278,1007595,704353,1002291,129665,255477,734325,40326,157381,743698,995237,505186,858418,500184,208342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]