SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805810 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805810 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578055,99985,747332,173519,438144,828856,504790,117975,549072,586213,670285,556103,919203,295457,974810,542647,377192,866821,622878,340257,20665,800969,81716,239169,756397,548750,202528,152991,501555,995632,651528,835983,935688,480709,122990,978175,12405,159855,613707,108936,36004,723116,1222,1002878,574140,521255,880124,474183,572008,591231,828530,285326,273809,284068,897901,853328,906429,494238,980690,382562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]