SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550850 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550850 [ RunTime:0.001384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602664,376342,182447,355120,857982,892683,667237,1041712,436073,864598,638155,755159,338662,675091,749264,269037,859216,598124,618649,441318,955582,241744,62831,995587,867078,187128,851428,339905,1016850,222307,86924,518999,847372,307981,512737,623480,287080,938429,379438,160381,209331,42540,571244,39122,804270,884550,17427,756851,396417,166469,755189,90063,495211,765898,546166,370729,927731,166546,481084,403593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]