SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440220 LIMIT 1 [ RunTime:0.001127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440220 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196509,18151,668383,529281,883019,64039,321925,850286,560323,464839,337294,174800,607902,716581,994825,629265,780045,654908,47288,885629,535767,876855,567278,271102,459364,529838,958819,516600,506069,530245,82051,129487,993779,391328,462328,671972,392091,158682,462515,543784,189894,1037934,198723,39524,149209,480547,541020,1012559,156326,23367,437127,706783,282106,261489,774587,621997,423363,105174,472025,603613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]