SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461730 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461730 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535478,50016,660722,481881,603758,84656,352842,659651,594085,253651,1028283,604756,251235,188445,338694,13510,976491,690007,829527,162536,613573,866790,857270,131627,317809,858592,544810,41233,254290,601183,290692,127156,569495,281731,435867,898050,811773,879753,139135,179451,973009,914232,145532,492486,192017,813040,673918,781320,838840,885864,680616,752717,219822,616869,893425,618575,975998,457340,420836,117894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]