SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017027 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017027 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815964,986366,845076,675839,336954,467085,864013,401761,699140,287723,823323,2484,795147,851335,861441,987108,1033254,222694,581375,983477,793889,255060,939011,12112,863798,49333,533500,13512,102733,847642,393796,970393,353984,993568,1033046,357956,21353,755446,390733,206547,942235,706755,665493,899239,443125,610601,372321,508505,359562,1028089,114709,724778,702906,35751,562731,230705,788158,556718,841189,996412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]