SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531200 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531200 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99732,2691,324643,7999,161206,1004009,160871,51201,346733,882805,947721,923875,137895,815892,322199,96102,701860,127326,725753,48975,849033,876923,138165,693155,61409,812644,274910,163059,957756,505614,789329,218746,508941,788121,961968,490466,491446,646355,245825,837032,457536,846142,736117,701361,962334,689964,221417,952839,991458,712442,211177,591609,1012637,1015910,988055,177506,709391,834602,359243,855737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]