SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648156 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648156 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692641,754773,31382,174650,1022493,214619,37203,364940,82394,491009,336497,323618,814571,184278,14817,1020717,182363,175603,358312,924338,868089,647685,447486,110969,25882,357500,1033673,109070,546202,736190,635812,373727,474249,369969,159460,744152,28249,456777,176023,606095,258649,474163,646755,538764,606380,859298,884819,473560,289732,208899,903454,334772,617899,497354,82816,1034312,365126,1033394,541723,603792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]