SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986012 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986012 [ RunTime:0.003636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61322,964007,192634,993560,729540,233470,262653,1047100,337986,907313,256315,920960,457848,479325,252333,605669,11381,445934,735583,308355,450475,978501,154015,932684,725010,988520,776055,720447,497995,387157,215607,41169,419115,476101,57370,414461,979341,254756,475650,927471,817212,557799,116317,833683,178010,535075,848796,1023049,193481,243218,976375,1040201,293059,284177,603523,795777,352588,563942,451203,733505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000333s ]