SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415011 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415011 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717577,282267,1020012,82180,84767,949575,273001,157070,816707,28833,581449,373406,960421,378631,702126,624158,245358,293204,214544,1016635,651542,1030911,38417,673968,490268,287682,428721,854665,669482,887302,561053,470465,24691,718229,546259,936374,684897,668803,819539,263256,337838,809524,285741,696179,990745,349533,533113,636175,349480,825606,376386,1026512,698294,459622,660815,69689,765600,556725,537422,794994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]