SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447609 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447609 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664550,524687,109443,976908,408784,678640,824008,498649,327438,533173,1016354,601200,565952,657616,168569,331858,207213,278927,1024572,956124,296935,435539,914356,226878,585759,525420,147268,121550,554820,159760,725950,1017450,103002,519316,528364,1031051,923554,1010031,586327,720887,667573,837064,752190,709630,142091,757746,247090,584669,450417,957513,896236,783061,212351,1017927,1023695,524900,258610,622618,690914,48321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]