SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039087 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039087 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040293,970104,1041460,60186,36528,597313,740805,696345,645829,271596,245064,287318,452706,819579,492446,525120,91553,707957,123287,304815,796619,930861,54805,837153,19622,913591,969360,278968,617310,430525,24656,53897,156536,885355,699802,430414,530300,703395,411677,192315,143643,131718,843642,517958,74456,870408,115383,195584,422166,395738,263068,933707,22563,400347,420143,803196,501504,982145,525660,918049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]