SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533698 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533698 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012983,233236,20374,1026323,426239,432270,678392,169329,316917,701452,966131,53255,847190,265412,705436,869884,20275,586344,523612,490154,114290,62890,748088,558492,1042948,645932,762866,611297,662140,862807,342095,890741,745718,250532,984490,75507,909283,294796,281024,289930,968330,1007070,865405,516964,111604,1020970,255045,780693,924138,815470,494446,140632,271846,1048690,117411,916902,291630,289572,602105,98100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]