SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417910 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417910 [ RunTime:0.004499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967153,49070,659856,654229,649375,327690,47197,639141,1014704,572623,151718,844036,211774,648954,419623,786871,21111,52197,162341,72333,318866,653590,643801,1020536,624042,1021919,72428,110502,923003,727949,136059,275609,213460,5613,354719,875592,979865,1006714,575962,585518,60147,389769,741591,142161,895544,491339,457249,565337,194480,342616,268876,963649,582034,870262,938729,361527,684133,222573,196556,220153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]