SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581012 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581012 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269290,461554,283296,16539,575508,605881,173447,950209,290571,439084,571936,295019,417199,300017,994470,873846,636626,259786,243217,490881,910558,144118,152672,257675,28694,723919,865336,138443,83989,240383,926109,831834,514843,483832,224117,26611,26547,57477,929797,940090,303016,326808,108869,272755,982053,143960,990568,682491,284289,940804,450123,50608,556194,1005079,243839,395824,268000,757378,969156,329154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]