SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569038 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569038 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842016,104668,1039699,599650,1032314,49920,261056,121112,22585,932402,844693,456312,8746,794294,403639,338198,796976,210728,802257,941405,419876,124458,358821,47133,787845,534507,725469,1031731,526427,328570,116707,108279,244363,982888,969733,1004279,87609,757445,539222,839484,585076,186052,25524,318482,180854,412087,59652,452494,646090,59968,973177,849640,103763,264003,1045308,916323,330073,670712,809072,276929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]