SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801483 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801483 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221271,812867,70467,955940,849022,558188,427470,958524,192867,131538,273923,982098,940927,753074,140673,60264,476306,187444,899301,44716,122792,742578,460653,808801,816087,260681,998727,46324,855582,739818,513351,71390,715244,142195,454394,72375,828334,800276,704464,418217,679043,277163,521983,932861,251077,616486,192946,39790,809895,681281,17589,149777,151351,397821,668023,680538,758031,260157,153091,900121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]