SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042992 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042992 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514898,690067,740607,57381,891230,152755,230886,777955,319963,788339,171011,1039945,536111,223848,849341,548151,350292,287978,637705,8459,209524,143946,801499,38183,671657,144412,585683,777001,29431,377799,305518,919459,558840,46426,218156,766315,403876,1031512,239828,396434,1017623,1008984,749925,14869,701959,198475,331499,975667,970032,956245,921582,728005,854328,362889,127845,504236,219842,720065,551131,558225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]