SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410040 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410040 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440459,672220,1011058,417647,88400,401034,664696,646918,307830,501685,887600,183143,373064,974261,819474,676701,659259,892912,998103,688926,219866,470260,527932,643077,552890,12891,415231,862618,1015253,404440,650224,227132,486574,186683,835798,920694,814682,87652,265206,575900,609419,775962,679241,30107,433480,403394,268323,534691,516926,1029501,637359,223406,765109,541280,890327,469095,750626,873300,276077,108140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]