SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547003 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547003 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280449,1001248,428280,605664,421794,881899,891406,691365,441550,324251,163389,374733,291916,507004,333204,420,265251,102958,90705,1012258,216185,1000758,582780,272694,88104,527618,818885,752202,885327,73124,160550,806533,94192,102332,43377,63869,943264,359917,795848,47380,757569,812141,251518,61795,25814,749959,578040,5955,148299,717962,893664,459950,518957,1034737,38228,374608,976931,496349,835513,100649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]