SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040736 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040736 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016075,123184,378700,964969,855605,217429,69087,1040010,794893,1026441,174066,204317,176557,1015262,631108,605431,883037,303328,559474,330162,62346,185641,653906,651083,856574,683305,260912,990356,371586,360768,370844,540750,681804,900117,769057,715766,726729,691155,1009785,458243,378992,519060,664973,443621,1000197,838922,201063,609983,389742,884032,870252,622126,251864,100395,592341,956483,360248,714472,514956,111142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]