SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10798 LIMIT 1 [ RunTime:0.001849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10798 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988643,232825,540391,68069,184953,442964,6654,201855,640048,970194,959086,905796,997908,815188,1131,469755,143140,246479,755534,939154,392874,734887,716860,30221,909680,44498,525742,292721,687619,514827,363016,353081,745784,184392,842567,946973,609755,723388,65155,728997,1016229,1012573,261099,924381,330932,855572,542828,151594,492457,465463,685720,554659,269398,289613,383047,286919,25,263113,1029164,168126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]