SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416320 LIMIT 1 [ RunTime:0.000662s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416320 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845817,684599,142623,213751,74590,199610,952590,197959,496662,968423,389,36219,761161,406800,476473,817262,824867,526349,503723,720093,53785,310735,866130,868839,710835,43229,906779,310512,255863,393924,910719,755741,907668,1030091,838430,254191,189027,289315,652420,759130,185268,966111,195973,45711,645324,142071,1039580,87457,314859,593970,187648,8758,709891,799365,918713,744656,298814,654815,991629,761997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003960s ]