SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 815650 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 815650 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010086,1002891,400560,404969,469734,308920,957172,724094,550210,897411,758088,19339,112810,856329,140179,744112,912995,380295,550832,191776,1042000,544243,647350,690106,159532,269114,586297,974153,825447,538484,464191,943478,987390,578310,119645,431270,643083,629800,263623,142241,362112,255531,651027,123695,811352,637416,395706,525270,116491,358447,124238,1040421,893118,807637,564,629036,38503,675457,701036,237964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 815650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 815650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]