SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415080 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415080 [ RunTime:0.001436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452419,312226,508006,919249,56336,587062,21649,1023710,855265,846961,926976,815616,427106,591596,15841,912244,11683,706701,996437,921119,863695,447091,57196,236849,60995,625413,891043,920804,222470,569023,218784,39228,722978,731226,600254,459034,748310,12504,390618,159672,588590,45853,162506,279864,150575,486383,974965,383302,662303,717160,954863,626375,815824,508723,1022999,510861,876943,674895,334242,646183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]