SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025842 LIMIT 1 [ RunTime:0.001053s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025842 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512200,133775,404319,288085,394395,96204,394379,793970,478436,458322,799166,986691,1008171,408353,776703,225330,328459,392994,473227,691807,907620,172590,1037705,706686,928861,1031410,157447,667066,469412,528660,345832,191514,32192,577784,925159,541828,339163,369046,769625,526183,222878,116431,812663,92902,317930,26506,95032,222533,800378,712004,137288,45189,744378,718915,919408,626425,777245,399002,185920,115768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.038908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003267s ]