SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514079 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514079 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82291,831073,659870,591370,1009154,951831,808576,234253,123352,916083,575807,98217,939147,861802,1015429,567396,634871,82858,491459,825130,629332,1047266,722023,1021880,723585,1032871,126486,803618,178945,822663,188125,2778,861186,814472,849457,787070,768751,695391,254868,204864,6636,88418,403939,196831,130259,19504,68217,959525,314632,800827,634712,776492,383434,523674,773468,946514,802998,299973,169901,233523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]