SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498180 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498180 [ RunTime:0.003177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238498,151992,182175,865231,115789,547988,687210,850042,338452,706655,982405,119424,988853,379953,1039912,486821,919829,815969,260054,314203,499282,859686,614017,563259,723084,247893,594167,551663,728039,734583,751417,563267,43089,1037487,659970,164222,213165,748679,1040836,938761,558021,605883,42563,1039490,507567,929436,518716,600034,229350,1001632,196355,78627,958780,397621,756593,950252,1011932,551110,857623,598048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]