SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301031 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301031 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613193,497054,888608,448246,659974,719070,777138,717002,568733,175063,930089,523964,545400,1031560,857929,646697,913068,375304,751985,907822,306480,909981,164877,111860,747272,408162,665020,255468,701777,920320,867805,699274,150801,410229,741688,189869,175344,398923,491728,501582,299269,551059,900924,985863,371020,93829,622161,249882,633558,1018344,713147,689816,751121,318838,477296,91837,231454,432593,231748,277241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]