SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020605 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020605 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455669,237851,369944,341958,33776,118922,629486,991807,873521,21103,747299,639887,350791,891329,710977,633188,821746,261825,628668,606719,281832,984966,845833,279675,481306,625573,156929,633214,475470,481278,331937,134536,95328,474255,311439,795308,998873,440438,709855,233777,622690,916283,338092,980085,64935,1024739,683989,600983,499973,302449,175736,279206,538071,706378,475690,219002,69369,826690,384765,201215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]