SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419501 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419501 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453301,441731,335542,726378,248945,436795,929223,94411,183501,948823,965378,239832,60169,1033738,933,269901,240035,654605,385008,987113,134889,269977,340920,608915,705508,177828,198355,666791,666381,532523,74217,704848,671407,610306,566850,856879,12896,148828,1005749,208133,813767,659121,341360,362367,758138,391798,13279,595898,90395,156541,107449,839670,414706,950048,861664,344477,43940,342384,151957,1024157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]