SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329185 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329185 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921003,821509,816516,604542,197915,974172,162731,254222,661958,37866,527292,124758,425270,16132,713054,931159,865579,405559,516747,727137,931335,20589,995828,963829,579376,300130,385970,45305,526332,7809,698253,372466,258929,929151,977034,836172,30081,12662,677492,270393,37975,547837,183111,717897,712158,949790,890339,459068,1039985,554779,361277,106209,482873,335673,876836,105446,199080,744250,629717,395548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001440s ]