SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531021 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531021 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134358,745808,263160,530221,29300,474539,625607,1030273,515650,687932,511123,339248,325653,648181,315663,764556,996638,228172,393164,800298,879459,561318,664480,949731,681303,289413,774336,1007290,211235,560121,844435,331842,876492,610469,132800,917773,923210,638673,637182,123199,1045045,778323,849562,825053,100269,621338,363357,721975,88873,889047,775280,760870,821130,576302,459858,442031,858469,242261,35172,566565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]