SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689276 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689276 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594127,815689,419547,224090,686338,1043623,496252,819958,861048,501907,367553,286321,157942,744931,515742,29909,704105,435212,134326,248908,653954,754270,1872,837878,24939,309112,731000,170488,1019015,525193,780295,161865,205554,109059,729923,468717,19522,652106,737178,181400,352122,897131,713623,794852,286345,669028,666325,262813,744812,525680,541703,833381,917671,187870,591447,266066,337818,177639,960175,734930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]