SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992016 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992016 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274632,305066,7391,591679,639739,981030,733999,629516,886667,595786,991669,912099,176482,184647,399180,556104,509163,1034653,326286,31815,1012626,401902,413085,501842,841176,699572,579162,120847,910536,26161,999712,817619,1048549,876776,575336,1009797,304948,510914,847316,698411,641453,836005,432849,535513,467889,76679,676239,1008592,316953,998283,322639,208405,956899,986804,878866,928025,229233,875619,221983,1035732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]