SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419138 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419138 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301020,531137,735210,950604,512461,686669,266389,218003,133663,827735,60170,929900,244962,510682,181112,348844,888447,258478,249,585464,455972,414152,714942,167285,1036851,568152,224401,249129,760971,398452,223911,805937,440060,511770,220140,115855,730210,1021901,586897,776592,767111,646997,52880,190683,221733,928353,706428,1040775,943278,800649,822334,50605,614048,756892,128246,758431,804388,408055,520709,16977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]