SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548802 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548802 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257982,452900,514387,444234,601430,294799,265688,74265,521709,182876,60072,61294,592022,422192,822650,286110,95606,688206,544765,595708,717132,664976,443805,772391,295426,981528,733638,380576,719176,958651,483520,519101,240525,163819,157545,782765,690442,352070,713539,400748,315253,813446,131275,448151,919607,475091,291805,697727,911229,146959,454554,606278,109840,876632,718068,679832,21239,504607,540202,201948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]